• Queries: Any search using Quick Query or a Query icon may be faster if the field being searched has had an Index built for it (meaning that this field is the top entry in an Index window).
When using Quick Query or a Query icon, you will be assured of the fastest possible search if there is no Index selected for that form in the View window.
• Calculations: If you use a Summary tile such as Min or Max, the Field or calculation being summarized should be Indexed.
Any field that appears in the second hole of a Lookup Tile should be indexed. This also applies to the Sub-Tiles.
A calculation that is used more than once should be made into a separate Abacus, and inserted into other calculations wherever needed.
The ‘Undefined becomes …’ tile should be used instead of the If/then/else Tile to provide replacement values for undefined fields or calculations.
